********************************************************************************
*                    CLEANING OF STUDENT SURVEY FINAL DATASET                  *
*==============================================================================*
* Date created: 10/12/2018                                                     *
* Last date edited: 20/01/2019                                                 *
* Uses: data from Student Survey Final.dta dataset and correctedValues_end.dta *
* Version : Stata 15                                                           *
* Description: This dofile is part of the cleaning work on Educate! for its    *
* student endline survey dataset. It iterates the cleaning work done on the    *
* above dataset                                                                *
*==============================================================================*

* Cleaning _other responses in the dataset
	readreplace using correctedValues_end.dta, id(studentid_202) variable(names) value(values) use


* Adding another choice to the question light_308 : 308. What is the main energy source for lighting in your household?
	#delimit ;
	label def light_308
		10 "Telephone"
		, add
		;
	#delimit cr
	
	drop light_other_308

	
* Dropped variable light_other_308 as it contained no information
	drop floor_house_other_303	
	
	
* Adding a choice to question water_305 : Where does your household mainly get drinking water?
	#delimit ;
	label def water_305
		8 "Purified water"
		, add
		;
	#delimit cr

	
* Dropping these _other variable as they contained no information
	drop water_other_305
	drop fath_occup_other_309
	drop moth_occup_other_309
	drop educ_fath_other_310
	drop educ_moth_other_310
	drop educ_sibling_other_310
	
		
* Adding choices to question option_500 : 500.b. Current option
	#delimit ;	
		label def option_500
		11 "Maths-Computer-Economics(MCE)" ///
		12 "English-Kinyarwanda-Kiswahili(EKK)" ///
		13 "Litterature-Economics-Geography (LEG)" ///
		14 "Litterature- French-Kinyarwanda(LFK)" ///
		15 "Literature-kiswahili and kinyarwanda(LKK)" ///
		16 "History-Economics-Literature(HEL)"
		, add
	;
	#delimit cr
	drop option_500_other
		
		
* Cleaning type_busi_402 question : My own business "402. For each type of business listed here, list the number of businesses in which you are currently actively involved:/"
	label variable type_busi_402_a_ "402. For each type of business listed here, list the number of businesses in which you are currently actively involved:/"
	label define own_business 1 "Yes" 0 "No"
	label values type_busi_402_a_ own_business
		
	label variable type_busi_402_b_ "402. For each type of business listed here, list the number of businesses in which you are currently actively involved:/"
	label define bus_club_business 1 "Yes" 0 "No"
	label values type_busi_402_b_ bus_club_business
		
	label variable type_busi_402_c_ "402. For each type of business listed here, list the number of businesses in which you are currently actively involved:/"
	label define shared_business_outschool 1 "Yes" 0 "No"
	label values type_busi_402_c_ shared_business_outschool
		
	label variable type_busi_402_d_ "402. For each type of business listed here, list the number of businesses in which you are currently actively involved:/"
	label define family_business 1 "Yes" 0 "No"
	label values type_busi_402_d_ family_business
	
**cleaning 403. Of these businesses in which you are actively involved, on which type of business do you spend most time?
	replace mosttime_busi_403 = "1" if mosttime_busi_403 == "a."
	replace mosttime_busi_403 = "2" if mosttime_busi_403 == "b."
	replace mosttime_busi_403 = "3" if mosttime_busi_403 == "c."
	replace mosttime_busi_403 = "4" if mosttime_busi_403 ==	"d."
	destring mosttime_busi_403, replace

	la def mosttime_busi_403_lab 1 "My own business" ///
						2 "Business started through a student business club" ///
						3 "Business owned by me and my peers outside school" ///
						4 "Family business"
	la values mosttime_busi_403 mosttime_busi_403_lab
		  
* Cleaning question stream_500: 500.c. Current stream
	destring stream_500, replace force
	label define stream_500lab 1 "A" 2 "B" 3 "C" 4 "D" 5 "E" 6 "F" 7 "other"
	label values stream_500 stream_500lab
	drop stream_other_500
		
		
* Adding an answer choice to typesupp_702	
	#delimit ;	
		label def typesupp_702_other
		-99 "Don't know"
		, add
		;
	#delimit cr
	
	
* Cleaning the variable make_product_706 "706. What product did you learn how to make at school?"
	label variable make_product_706_1 "706. What product did you learn how to make at school?"
	label define Candles 1 "Yes" 0 "No"
	label values make_product_706_1 Candles

	label variable make_product_706_2 "706. What product did you learn how to make at school?"
	label define Liquid_Soap 1 "Yes" 0 "No"
	label values make_product_706_2 Liquid_Soap

	label variable make_product_706_3 "706. What product did you learn how to make at school?"
	label define Paper_bags 1 "Yes" 0 "No"
	label values make_product_706_3 Paper_bags
		
	label variable make_product_706_4 "706. What product did you learn how to make at school?"
	label define Paper_beads 1 "Yes" 0 "No"
	label values make_product_706_4 Paper_beads

	label variable make_product_706_5 "706. What product did you learn how to make at school?"
	label define Baskets 1 "Yes" 0 "No"
	label values make_product_706_5 Baskets

	label variable make_product_706_6 "706. What product did you learn how to make at school?"
	label define make_product_706_6_other 1 "yes" 0 "No"
	label values make_product_706_6 make_product_706_6_other
	
	
* Cleaning occup_1001 question : "1001. After school, what occupation would you like to have in your life?"
	destring occup_1001, replace force
	label define occup_1001 1 "Farming" 2 "Business" 3 "Petty trading" 4 "Skilled labor (carpenter, tailor, etc)" ///
	5 "Professional/salaried (lawyer, doctor, accountant, teacher, etc)" 6 "Other" -99 "Don't know"
	label values occup_1001 occup_1001
	drop occup_1001_other
	
	

	drop bus_relation_405_2 -bus_relation_405_90
	
	destring bus_relation_405_1, replace

	label variable bus_relation_405_1 "405. What is the relationship with your parterners?"
	label define bus_relation_405_1lab 1 "Parent" 2	"Sibling" 3	"Other relative" 4 "Friend/classmate" 5	"Other"
	label values bus_relation_405_1 bus_relation_405_1lab

	
* Cleaning the howmuch_401a question "401. a How much have you earned in the last 2 months? Include all your sources o
	tostring studentid_202, replace
	replace howmuch_401a = "5000" if studentid_202 == "451005"
	replace howmuch_401a = "20000" if studentid_202 == "451006"
	replace howmuch_401a = "30000" if studentid_202 == "451043"
	replace howmuch_401a = "20000" if studentid_202 == "451051"
	replace howmuch_401a = "4000" if studentid_202 == "451265"
	replace howmuch_401a = "10000" if studentid_202 == "4011231"
	replace howmuch_401a = "20000" if studentid_202 == "4510414"
	replace howmuch_401a = "6000" if studentid_202 == "4512622"
	replace howmuch_401a = "8500" if studentid_202 == "4513915"
	replace howmuch_401a = "30000" if studentid_202 == "40112310"
	replace howmuch_401a = "22000" if studentid_202 == "50712014"
	replace howmuch_401a = "" if howmuch_401a == "-99" | howmuch_401a == "0"
	destring howmuch_401a, replace
	
* Cleaning the lasttime_profits_410 question 410. During the last ${often_earn_409_label} perdiod, this business had how muc
	/*
	destring lasttime_profits_410, replace ignore("rwf ,")
	replace lasttime_profits_410 = . if lasttime_profits_410 == -99
	*/
	
	drop often_earn_409_label
	replace lasttime_profits_410 = "20000" if studentid_202 == "451004"
	replace lasttime_profits_410 = "20000" if studentid_202 == "451005"
	replace lasttime_profits_410 = "15000" if studentid_202 == "451006"
	replace lasttime_profits_410 = "20000" if studentid_202 == "451051"
	replace lasttime_profits_410 = "1250" if studentid_202 == "451125"
	replace lasttime_profits_410 = "1500" if studentid_202 == "4021066"
	replace lasttime_profits_410 = "30000" if studentid_202 == "4510414"
	replace lasttime_profits_410 = "1000" if studentid_202 == "4513316"
	replace lasttime_profits_410 = "5000" if studentid_202 == "40111510"
	replace lasttime_profits_410 = "3000" if studentid_202 == "40310822"
	replace lasttime_profits_410 = "" if studentid_202 == "40311120"
	replace lasttime_profits_410 = "10000" if studentid_202 == "50712014"
	replace lasttime_profits_410 = "20000" if studentid_202 == "451913417"
	replace lasttime_profits_410 = "" if lasttime_profits_410 == "-99" | lasttime_profits_410 == "0"
	destring lasttime_profits_410, replace force
	

* Cleaning unit_dist_205 question 205. About how long does it take to travel from your home to schools?
	replace unit_dist_205 = "120" if studentid_202 == "450125"
	replace unit_dist_205 = "160" if studentid_202 == "450129"
	replace unit_dist_205 = "180" if studentid_202 == "450336"
	replace unit_dist_205 = "5" if studentid_202 == "451003"
	replace unit_dist_205 = "3" if studentid_202 == "451004"
	replace unit_dist_205 = "20" if studentid_202 == "451005"
	replace unit_dist_205 = "30" if studentid_202 == "451006"
	replace unit_dist_205 = "45" if studentid_202 == "451007"
	replace unit_dist_205 = "7" if studentid_202 == "451009"
	replace unit_dist_205 = "90" if studentid_202 == "451008"
	replace unit_dist_205 = "60" if studentid_202 == "451043"
	replace unit_dist_205 = "15" if studentid_202 == "451045"
	replace unit_dist_205 = "70" if studentid_202 == "451046"
	replace unit_dist_205 = "40" if studentid_202 == "451049"
	replace unit_dist_205 = "90" if studentid_202 == "451055"
	replace unit_dist_205 = "40" if studentid_202 == "451056"
	replace unit_dist_205 = "15" if studentid_202 == "451058"
	replace unit_dist_205 = "20" if studentid_202 == "451112"
	replace unit_dist_205 = "60" if studentid_202 == "451123"
	replace unit_dist_205 = "60" if studentid_202 == "451125"
	replace unit_dist_205 = "60" if studentid_202 == "451126"
	replace unit_dist_205 = "40" if studentid_202 == "451127"
	replace unit_dist_205 = "30" if studentid_202 == "451129"
	replace unit_dist_205 = "60" if studentid_202 == "451132"
	replace unit_dist_205 = "60" if studentid_202 == "451133"
	replace unit_dist_205 = "40" if studentid_202 == "451134"
	replace unit_dist_205 = "60" if studentid_202 == "451135"
	replace unit_dist_205 = "60" if studentid_202 == "451137"
	replace unit_dist_205 = "90" if studentid_202 == "451138"
	replace unit_dist_205 = "80" if studentid_202 == "451139"
	replace unit_dist_205 = "60" if studentid_202 == "451142"
	replace unit_dist_205 = "35" if studentid_202 == "451173"
	replace unit_dist_205 = "30" if studentid_202 == "451174"
	replace unit_dist_205 = "5" if studentid_202 == "451177"
	replace unit_dist_205 = "120" if studentid_202 == "451178"
	replace unit_dist_205 = "3" if studentid_202 == "451179"
	replace unit_dist_205 = "20" if studentid_202 == "451191"
	replace unit_dist_205 = "40" if studentid_202 == "451195"
	replace unit_dist_205 = "20" if studentid_202 == "451196"
	replace unit_dist_205 = "90" if studentid_202 == "451197"
	replace unit_dist_205 = "90" if studentid_202 == "451198"
	replace unit_dist_205 = "40" if studentid_202 == "451199"
	replace unit_dist_205 = "60" if studentid_202 == "451201"
	replace unit_dist_205 = "60" if studentid_202 == "451207"
	replace unit_dist_205 = "30" if studentid_202 == "451208"
	replace unit_dist_205 = "40" if studentid_202 == "451209"
	replace unit_dist_205 = "45" if studentid_202 == "451232"
	replace unit_dist_205 = "80" if studentid_202 == "451235"
	replace unit_dist_205 = "20" if studentid_202 == "451236"
	replace unit_dist_205 = "120" if studentid_202 == "451237"
	replace unit_dist_205 = "45" if studentid_202 == "451242"
	replace unit_dist_205 = "15" if studentid_202 == "451243"
	replace unit_dist_205 = "20" if studentid_202 == "451264"
	replace unit_dist_205 = "50" if studentid_202 == "451265"
	replace unit_dist_205 = "120" if studentid_202 == "451267"
	replace unit_dist_205 = "20" if studentid_202 == "451316"
	replace unit_dist_205 = "40" if studentid_202 == "451361"
	replace unit_dist_205 = "15" if studentid_202 == "451362"
	replace unit_dist_205 = "40" if studentid_202 == "451391"
	replace unit_dist_205 = "40" if studentid_202 == "451393"
	replace unit_dist_205 = "120" if studentid_202 == "4010141"
	replace unit_dist_205 = "90" if studentid_202 == "4010142"
	replace unit_dist_205 = "180" if studentid_202 == "4010144"
	replace unit_dist_205 = "150" if studentid_202 == "4010146"
	replace unit_dist_205 = "30" if studentid_202 == "4010147"
	replace unit_dist_205 = "120" if studentid_202 == "4010161"
	replace unit_dist_205 = "120" if studentid_202 == "4010163"
	replace unit_dist_205 = "120" if studentid_202 == "4010164"
	replace unit_dist_205 = "150" if studentid_202 == "4010167"
	replace unit_dist_205 = "120" if studentid_202 == "4010165"
	replace unit_dist_205 = "240" if studentid_202 == "4010271"
	replace unit_dist_205 = "60" if studentid_202 == "4010272"
	replace unit_dist_205 = "25" if studentid_202 == "4010273"
	replace unit_dist_205 = "60" if studentid_202 == "4010274"
	replace unit_dist_205 = "60" if studentid_202 == "4010275"
	replace unit_dist_205 = "90" if studentid_202 == "4010277"
	replace unit_dist_205 = "120" if studentid_202 == "4010278"
	replace unit_dist_205 = "5" if studentid_202 == "4010307"
	replace unit_dist_205 = "5" if studentid_202 == "4010308"
	replace unit_dist_205 = "3" if studentid_202 == "4010309"
	replace unit_dist_205 = "45" if studentid_202 == "4010328"
	replace unit_dist_205 = "15" if studentid_202 == "4011121"
	replace unit_dist_205 = "40" if studentid_202 == "4011151"
	replace unit_dist_205 = "40" if studentid_202 == "4011172"
	replace unit_dist_205 = "30" if studentid_202 == "4011173"
	replace unit_dist_205 = "5" if studentid_202 == "4011174"
	replace unit_dist_205 = "90" if studentid_202 == "4011176"
	replace unit_dist_205 = "45" if studentid_202 == "4011177"
	replace unit_dist_205 = "5" if studentid_202 == "4011178"
	replace unit_dist_205 = "20" if studentid_202 == "4011195"
	replace unit_dist_205 = "60" if studentid_202 == "4011175"
	replace unit_dist_205 = "20" if studentid_202 == "4011198"
	replace unit_dist_205 = "40" if studentid_202 == "4011199"
	replace unit_dist_205 = "120" if studentid_202 == "4011222"
	replace unit_dist_205 = "20" if studentid_202 == "4011228"
	replace unit_dist_205 = "10" if studentid_202 == "4011231"
	replace unit_dist_205 = "60" if studentid_202 == "4011332"
	replace unit_dist_205 = "15" if studentid_202 == "4011334"
	replace unit_dist_205 = "180" if studentid_202 == "4020112"
	replace unit_dist_205 = "50" if studentid_202 == "4020113"
	replace unit_dist_205 = "240" if studentid_202 == "4020115"
	replace unit_dist_205 = "180" if studentid_202 == "4020116"
	replace unit_dist_205 = "180" if studentid_202 == "4020117"
	replace unit_dist_205 = "240" if studentid_202 == "4020119"
	replace unit_dist_205 = "210" if studentid_202 == "4020327"
	replace unit_dist_205 = "180" if studentid_202 == "4020329"
	replace unit_dist_205 = "80" if studentid_202 == "4021031"
	replace unit_dist_205 = "90" if studentid_202 == "4021032"
	replace unit_dist_205 = "60" if studentid_202 == "4021038"
	replace unit_dist_205 = "40" if studentid_202 == "4021039"
	replace unit_dist_205 = "50" if studentid_202 == "4021063"
	replace unit_dist_205 = "60" if studentid_202 == "4021064"
	replace unit_dist_205 = "45" if studentid_202 == "4021065"
	replace unit_dist_205 = "90" if studentid_202 == "4021066"
	replace unit_dist_205 = "40" if studentid_202 == "4021096"
	replace unit_dist_205 = "75" if studentid_202 == "4021097"
	replace unit_dist_205 = "120" if studentid_202 == "4021098"
	replace unit_dist_205 = "15" if studentid_202 == "4021104"
	replace unit_dist_205 = "2" if studentid_202 == "4021105"
	replace unit_dist_205 = "60" if studentid_202 == "4021108"
	replace unit_dist_205 = "30" if studentid_202 == "4021109"
	replace unit_dist_205 = "60" if studentid_202 == "4021111"
	replace unit_dist_205 = "60" if studentid_202 == "4021112"
	replace unit_dist_205 = "30" if studentid_202 == "4021116"
	replace unit_dist_205 = "30" if studentid_202 == "4021118"
	replace unit_dist_205 = "100" if studentid_202 == "4021173"
	replace unit_dist_205 = "120" if studentid_202 == "4021177"
	replace unit_dist_205 = "120" if studentid_202 == "4030117"
	replace unit_dist_205 = "120" if studentid_202 == "4030118"
	replace unit_dist_205 = "60" if studentid_202 == "4030119"
	replace unit_dist_205 = "10" if studentid_202 == "4030211"
	replace unit_dist_205 = "120" if studentid_202 == "4030212"
	replace unit_dist_205 = "120" if studentid_202 == "4030213"
	replace unit_dist_205 = "20" if studentid_202 == "4030214"
	replace unit_dist_205 = "50" if studentid_202 == "4030215"
	replace unit_dist_205 = "5" if studentid_202 == "4030219"
	replace unit_dist_205 = "300" if studentid_202 == "4030308"
	replace unit_dist_205 = "270" if studentid_202 == "4030309"
	replace unit_dist_205 = "90" if studentid_202 == "4030311"
	replace unit_dist_205 = "240" if studentid_202 == "4030319"
	replace unit_dist_205 = "150" if studentid_202 == "4030376"
	replace unit_dist_205 = "45" if studentid_202 == "4030378"
	replace unit_dist_205 = "210" if studentid_202 == "4030379"
	replace unit_dist_205 = "90" if studentid_202 == "4030501"
	replace unit_dist_205 = "5" if studentid_202 == "4030575"
	replace unit_dist_205 = "150" if studentid_202 == "4030577"
	replace unit_dist_205 = "120" if studentid_202 == "4030578"
	replace unit_dist_205 = "40" if studentid_202 == "4031011"
	replace unit_dist_205 = "30" if studentid_202 == "4031015"
	replace unit_dist_205 = "70" if studentid_202 == "4031016"
	replace unit_dist_205 = "40" if studentid_202 == "4031017"
	replace unit_dist_205 = "60" if studentid_202 == "4031019"
	replace unit_dist_205 = "30" if studentid_202 == "4031101"
	replace unit_dist_205 = "45" if studentid_202 == "4031102"
	replace unit_dist_205 = "60" if studentid_202 == "4031126"
	replace unit_dist_205 = "50" if studentid_202 == "4031128"
	replace unit_dist_205 = "60" if studentid_202 == "4031129"
	replace unit_dist_205 = "20" if studentid_202 == "4031142"
	replace unit_dist_205 = "30" if studentid_202 == "4031143"
	replace unit_dist_205 = "15" if studentid_202 == "4031144"
	replace unit_dist_205 = "30" if studentid_202 == "4031146"
	replace unit_dist_205 = "15" if studentid_202 == "4031147"
	replace unit_dist_205 = "40" if studentid_202 == "4031149"
	replace unit_dist_205 = "5" if studentid_202 == "4031211"
	replace unit_dist_205 = "20" if studentid_202 == "4031212"
	replace unit_dist_205 = "100" if studentid_202 == "4031214"
	replace unit_dist_205 = "60" if studentid_202 == "4031218"
	replace unit_dist_205 = "90" if studentid_202 == "4031231"
	replace unit_dist_205 = "120" if studentid_202 == "4031232"
	replace unit_dist_205 = "120" if studentid_202 == "4031233"
	replace unit_dist_205 = "30" if studentid_202 == "4031234"
	replace unit_dist_205 = "40" if studentid_202 == "4031239"
	replace unit_dist_205 = "40" if studentid_202 == "4031252"
	replace unit_dist_205 = "20" if studentid_202 == "4031256"
	replace unit_dist_205 = "60" if studentid_202 == "4031258"
	replace unit_dist_205 = "70" if studentid_202 == "4031259"
	replace unit_dist_205 = "150" if studentid_202 == "4031281"
	replace unit_dist_205 = "40" if studentid_202 == "4031291"
	replace unit_dist_205 = "10" if studentid_202 == "4031322"
	replace unit_dist_205 = "50" if studentid_202 == "4031323"
	replace unit_dist_205 = "40" if studentid_202 == "4031328"
	replace unit_dist_205 = "40" if studentid_202 == "4031329"
	replace unit_dist_205 = "10" if studentid_202 == "4150516"
	replace unit_dist_205 = "300" if studentid_202 == "4501210"
	replace unit_dist_205 = "120" if studentid_202 == "4501211"
	replace unit_dist_205 = "60" if studentid_202 == "4501220"
	replace unit_dist_205 = "180" if studentid_202 == "4501221"
	replace unit_dist_205 = "120" if studentid_202 == "4501223"
	replace unit_dist_205 = "90" if studentid_202 == "4501224"
	replace unit_dist_205 = "120" if studentid_202 == "4503310"
	replace unit_dist_205 = "40" if studentid_202 == "4503312"
	replace unit_dist_205 = "30" if studentid_202 == "4503313"
	replace unit_dist_205 = "30" if studentid_202 == "4503315"
	replace unit_dist_205 = "30" if studentid_202 == "4503316"
	replace unit_dist_205 = "120" if studentid_202 == "4503317"
	replace unit_dist_205 = "120" if studentid_202 == "4503318"
	replace unit_dist_205 = "120" if studentid_202 == "4503512"
	replace unit_dist_205 = "240" if studentid_202 == "4503514"
	replace unit_dist_205 = "40" if studentid_202 == "4510212"
	replace unit_dist_205 = "30" if studentid_202 == "4510215"
	replace unit_dist_205 = "50" if studentid_202 == "4510413"
	replace unit_dist_205 = "40" if studentid_202 == "4510414"
	replace unit_dist_205 = "25" if studentid_202 == "4510417"
	replace unit_dist_205 = "40" if studentid_202 == "4510418"
	replace unit_dist_205 = "50" if studentid_202 == "4510510"
	replace unit_dist_205 = "10" if studentid_202 == "4510515"
	replace unit_dist_205 = "60" if studentid_202 == "4510214"
	replace unit_dist_205 = "10" if studentid_202 == "4511112"
	replace unit_dist_205 = "60" if studentid_202 == "4511116"
	replace unit_dist_205 = "20" if studentid_202 == "4511217"
	replace unit_dist_205 = "45" if studentid_202 == "4511218"
	replace unit_dist_205 = "10" if studentid_202 == "4511414"
	replace unit_dist_205 = "80" if studentid_202 == "4511418"
	replace unit_dist_205 = "120" if studentid_202 == "4511711"
	replace unit_dist_205 = "60" if studentid_202 == "4511712"
	replace unit_dist_205 = "30" if studentid_202 == "4511714"
	replace unit_dist_205 = "60" if studentid_202 == "4511717"
	replace unit_dist_205 = "40" if studentid_202 == "4511910"
	replace unit_dist_205 = "90" if studentid_202 == "4511911"
	replace unit_dist_205 = "40" if studentid_202 == "4511912"
	replace unit_dist_205 = "150" if studentid_202 == "4511913"
	replace unit_dist_205 = "30" if studentid_202 == "4511915"
	replace unit_dist_205 = "15" if studentid_202 == "4511916"
	replace unit_dist_205 = "90" if studentid_202 == "4512011"
	replace unit_dist_205 = "60" if studentid_202 == "4512012"
	replace unit_dist_205 = "30" if studentid_202 == "4512013"
	replace unit_dist_205 = "60" if studentid_202 == "4512014"
	replace unit_dist_205 = "20" if studentid_202 == "4512311"
	replace unit_dist_205 = "40" if studentid_202 == "4512312"
	replace unit_dist_205 = "120" if studentid_202 == "4512314"
	replace unit_dist_205 = "25" if studentid_202 == "4512315"
	replace unit_dist_205 = "40" if studentid_202 == "4512316"
	replace unit_dist_205 = "120" if studentid_202 == "4512317"
	replace unit_dist_205 = "120" if studentid_202 == "4512318"
	replace unit_dist_205 = "120" if studentid_202 == "4512319"
	replace unit_dist_205 = "40" if studentid_202 == "4512412"
	replace unit_dist_205 = "90" if studentid_202 == "4512414"
	replace unit_dist_205 = "80" if studentid_202 == "4512415"
	replace unit_dist_205 = "120" if studentid_202 == "4512417"
	replace unit_dist_205 = "60" if studentid_202 == "4512419"
	replace unit_dist_205 = "20" if studentid_202 == "4512420"
	replace unit_dist_205 = "60" if studentid_202 == "4512610"
	replace unit_dist_205 = "30" if studentid_202 == "4512616"
	replace unit_dist_205 = "30" if studentid_202 == "4512618"
	replace unit_dist_205 = "10" if studentid_202 == "4512620"
	replace unit_dist_205 = "30" if studentid_202 == "4512622"
	replace unit_dist_205 = "30" if studentid_202 == "4513015"
	replace unit_dist_205 = "30" if studentid_202 == "4513016"
	replace unit_dist_205 = "100" if studentid_202 == "4513019"
	replace unit_dist_205 = "15" if studentid_202 == "4513610"
	replace unit_dist_205 = "45" if studentid_202 == "4513614"
	replace unit_dist_205 = "50" if studentid_202 == "4513616"
	replace unit_dist_205 = "30" if studentid_202 == "4513617"
	replace unit_dist_205 = "15" if studentid_202 == "4513618"
	replace unit_dist_205 = "30" if studentid_202 == "4513910"
	replace unit_dist_205 = "30" if studentid_202 == "4513911"
	replace unit_dist_205 = "75" if studentid_202 == "4513913"
	replace unit_dist_205 = "60" if studentid_202 == "4513915"
	replace unit_dist_205 = "120" if studentid_202 == "5070107"
	replace unit_dist_205 = "40" if studentid_202 == "5070108"
	replace unit_dist_205 = "5" if studentid_202 == "5070552"
	replace unit_dist_205 = "5" if studentid_202 == "5070554"
	replace unit_dist_205 = "5" if studentid_202 == "5070559"
	replace unit_dist_205 = "60" if studentid_202 == "5071012"
	replace unit_dist_205 = "60" if studentid_202 == "5071014"
	replace unit_dist_205 = "15" if studentid_202 == "5071021"
	replace unit_dist_205 = "20" if studentid_202 == "5071029"
	replace unit_dist_205 = "90" if studentid_202 == "5071043"
	replace unit_dist_205 = "60" if studentid_202 == "5071044"
	replace unit_dist_205 = "60" if studentid_202 == "5071046"
	replace unit_dist_205 = "20" if studentid_202 == "5071049"
	replace unit_dist_205 = "5" if studentid_202 == "5071072"
	replace unit_dist_205 = "60" if studentid_202 == "5071073"
	replace unit_dist_205 = "180" if studentid_202 == "5071074"
	replace unit_dist_205 = "40" if studentid_202 == "5071075"
	replace unit_dist_205 = "60" if studentid_202 == "5071081"
	replace unit_dist_205 = "40" if studentid_202 == "5071085"
	replace unit_dist_205 = "20" if studentid_202 == "5071086"
	replace unit_dist_205 = "20" if studentid_202 == "5071087"
	replace unit_dist_205 = "25" if studentid_202 == "5071088"
	replace unit_dist_205 = "60" if studentid_202 == "5071111"
	replace unit_dist_205 = "10" if studentid_202 == "5071127"
	replace unit_dist_205 = "40" if studentid_202 == "5071155"
	replace unit_dist_205 = "20" if studentid_202 == "5071158"
	replace unit_dist_205 = "5" if studentid_202 == "5071181"
	replace unit_dist_205 = "240" if studentid_202 == "5071182"
	replace unit_dist_205 = "60" if studentid_202 == "5071187"
	replace unit_dist_205 = "60" if studentid_202 == "5071203"
	replace unit_dist_205 = "40" if studentid_202 == "5071205"
	replace unit_dist_205 = "30" if studentid_202 == "5071232"
	replace unit_dist_205 = "45" if studentid_202 == "5071236"
	replace unit_dist_205 = "80" if studentid_202 == "5071238"
	replace unit_dist_205 = "90" if studentid_202 == "5071522"
	replace unit_dist_205 = "25" if studentid_202 == "7050347"
	replace unit_dist_205 = "120" if studentid_202 == "7050349"
	replace unit_dist_205 = "180" if studentid_202 == "40101411"
	replace unit_dist_205 = "150" if studentid_202 == "40101412"
	replace unit_dist_205 = "210" if studentid_202 == "40101414"
	replace unit_dist_205 = "90" if studentid_202 == "40101416"
	replace unit_dist_205 = "180" if studentid_202 == "40101417"
	replace unit_dist_205 = "120" if studentid_202 == "40101419"
	replace unit_dist_205 = "120" if studentid_202 == "40101611"
	replace unit_dist_205 = "120" if studentid_202 == "40101612"
	replace unit_dist_205 = "120" if studentid_202 == "40102713"
	replace unit_dist_205 = "180" if studentid_202 == "40103211"
	replace unit_dist_205 = "15" if studentid_202 == "40111211"
	replace unit_dist_205 = "60" if studentid_202 == "40103215"
	replace unit_dist_205 = "15" if studentid_202 == "40111212"
	replace unit_dist_205 = "120" if studentid_202 == "40111213"
	replace unit_dist_205 = "240" if studentid_202 == "40111510"
	replace unit_dist_205 = "10" if studentid_202 == "40111717"
	replace unit_dist_205 = "150" if studentid_202 == "40112211"
	replace unit_dist_205 = "15" if studentid_202 == "40112310"
	replace unit_dist_205 = "20" if studentid_202 == "40112311"
	replace unit_dist_205 = "120" if studentid_202 == "40112312"
	replace unit_dist_205 = "90" if studentid_202 == "40113310"
	replace unit_dist_205 = "100" if studentid_202 == "40113314"
	replace unit_dist_205 = "35" if studentid_202 == "40113315"
	replace unit_dist_205 = "30" if studentid_202 == "40113318"
	replace unit_dist_205 = "25" if studentid_202 == "40113321"
	replace unit_dist_205 = "75" if studentid_202 == "40113322"
	replace unit_dist_205 = "60" if studentid_202 == "40201111"
	replace unit_dist_205 = "30" if studentid_202 == "40201113"
	replace unit_dist_205 = "240" if studentid_202 == "40201114"
	replace unit_dist_205 = "40" if studentid_202 == "40201116"
	replace unit_dist_205 = "60" if studentid_202 == "40201119"
	replace unit_dist_205 = "180" if studentid_202 == "40203212"
	replace unit_dist_205 = "90" if studentid_202 == "40203215"
	replace unit_dist_205 = "240" if studentid_202 == "40203216"
	replace unit_dist_205 = "150" if studentid_202 == "40203217"
	replace unit_dist_205 = "300" if studentid_202 == "40203218"
	replace unit_dist_205 = "270" if studentid_202 == "40203219"
	replace unit_dist_205 = "45" if studentid_202 == "40203221"
	replace unit_dist_205 = "180" if studentid_202 == "40203222"
	replace unit_dist_205 = "360" if studentid_202 == "40203223"
	replace unit_dist_205 = "50" if studentid_202 == "40210313"
	replace unit_dist_205 = "120" if studentid_202 == "40210315"
	replace unit_dist_205 = "60" if studentid_202 == "40210317"
	replace unit_dist_205 = "50" if studentid_202 == "40210319"
	replace unit_dist_205 = "90" if studentid_202 == "40211013"
	replace unit_dist_205 = "60" if studentid_202 == "40211014"
	replace unit_dist_205 = "40" if studentid_202 == "40211016"
	replace unit_dist_205 = "30" if studentid_202 == "40211017"
	replace unit_dist_205 = "25" if studentid_202 == "40211114"
	replace unit_dist_205 = "20" if studentid_202 == "40211117"
	replace unit_dist_205 = "105" if studentid_202 == "40211611"
	replace unit_dist_205 = "60" if studentid_202 == "40211612"
	replace unit_dist_205 = "120" if studentid_202 == "40211618"
	replace unit_dist_205 = "40" if studentid_202 == "40211712"
	replace unit_dist_205 = "90" if studentid_202 == "40211713"
	replace unit_dist_205 = "60" if studentid_202 == "40211715"
	replace unit_dist_205 = "80" if studentid_202 == "40211716"
	replace unit_dist_205 = "30" if studentid_202 == "40211717"
	replace unit_dist_205 = "120" if studentid_202 == "40211718"
	replace unit_dist_205 = "40" if studentid_202 == "40212110"
	replace unit_dist_205 = "45" if studentid_202 == "40212112"
	replace unit_dist_205 = "5" if studentid_202 == "40212113"
	replace unit_dist_205 = "30" if studentid_202 == "40212119"
	replace unit_dist_205 = "5" if studentid_202 == "40302113"
	replace unit_dist_205 = "30" if studentid_202 == "40302115"
	replace unit_dist_205 = "280" if studentid_202 == "40303017"
	replace unit_dist_205 = "60" if studentid_202 == "40303111"
	replace unit_dist_205 = "15" if studentid_202 == "40303112"
	replace unit_dist_205 = "20" if studentid_202 == "40303113"
	replace unit_dist_205 = "150" if studentid_202 == "40303116"
	replace unit_dist_205 = "30" if studentid_202 == "40303117"
	replace unit_dist_205 = "21" if studentid_202 == "40303711"
	replace unit_dist_205 = "150" if studentid_202 == "40303713"
	replace unit_dist_205 = "180" if studentid_202 == "40303715"
	replace unit_dist_205 = "90" if studentid_202 == "40303716"
	replace unit_dist_205 = "120" if studentid_202 == "40303729"
	replace unit_dist_205 = "30" if studentid_202 == "40305017"
	replace unit_dist_205 = "120" if studentid_202 == "40305021"
	replace unit_dist_205 = "240" if studentid_202 == "40305710"
	replace unit_dist_205 = "30" if studentid_202 == "40310111"
	replace unit_dist_205 = "30" if studentid_202 == "40310112"
	replace unit_dist_205 = "20" if studentid_202 == "40310820"
	replace unit_dist_205 = "30" if studentid_202 == "40310821"
	replace unit_dist_205 = "7" if studentid_202 == "40310822"
	replace unit_dist_205 = "30" if studentid_202 == "40310824"
	replace unit_dist_205 = "20" if studentid_202 == "40311214"
	replace unit_dist_205 = "30" if studentid_202 == "40312116"
	replace unit_dist_205 = "5" if studentid_202 == "40312117"
	replace unit_dist_205 = "30" if studentid_202 == "40312118"
	replace unit_dist_205 = "10" if studentid_202 == "40312121"
	replace unit_dist_205 = "60" if studentid_202 == "40312311"
	replace unit_dist_205 = "40" if studentid_202 == "40312314"
	replace unit_dist_205 = "30" if studentid_202 == "40312318"
	replace unit_dist_205 = "50" if studentid_202 == "40312320"
	replace unit_dist_205 = "60" if studentid_202 == "40312321"
	replace unit_dist_205 = "40" if studentid_202 == "40312510"
	replace unit_dist_205 = "20" if studentid_202 == "40312512"
	replace unit_dist_205 = "20" if studentid_202 == "40312516"
	replace unit_dist_205 = "60" if studentid_202 == "40312810"
	replace unit_dist_205 = "60" if studentid_202 == "40312811"
	replace unit_dist_205 = "30" if studentid_202 == "40312910"
	replace unit_dist_205 = "30" if studentid_202 == "40312912"
	replace unit_dist_205 = "50" if studentid_202 == "40313217"
	replace unit_dist_205 = "20" if studentid_202 == "40313218"
	replace unit_dist_205 = "15" if studentid_202 == "40313219"
	replace unit_dist_205 = "60" if studentid_202 == "40512010"
	replace unit_dist_205 = "10" if studentid_202 == "45191342"
	replace unit_dist_205 = "120" if studentid_202 == "45191343"
	replace unit_dist_205 = "10" if studentid_202 == "50701015"
	replace unit_dist_205 = "5" if studentid_202 == "50701016"
	replace unit_dist_205 = "90" if studentid_202 == "50701018"
	replace unit_dist_205 = "5" if studentid_202 == "50701021"
	replace unit_dist_205 = "40" if studentid_202 == "50710019"
	replace unit_dist_205 = "30" if studentid_202 == "50710118"
	replace unit_dist_205 = "10" if studentid_202 == "50710119"
	replace unit_dist_205 = "60" if studentid_202 == "50710210"
	replace unit_dist_205 = "120" if studentid_202 == "50710211"
	replace unit_dist_205 = "50" if studentid_202 == "50710216"
	replace unit_dist_205 = "2" if studentid_202 == "50710217"
	replace unit_dist_205 = "10" if studentid_202 == "50710218"
	replace unit_dist_205 = "40" if studentid_202 == "50710219"
	replace unit_dist_205 = "30" if studentid_202 == "50710413"
	replace unit_dist_205 = "120" if studentid_202 == "50710417"
	replace unit_dist_205 = "60" if studentid_202 == "50710422"
	replace unit_dist_205 = "30" if studentid_202 == "50710423"
	replace unit_dist_205 = "50" if studentid_202 == "50710513"
	replace unit_dist_205 = "35" if studentid_202 == "50710713"
	replace unit_dist_205 = "60" if studentid_202 == "50710716"
	replace unit_dist_205 = "60" if studentid_202 == "50710717"
	replace unit_dist_205 = "30" if studentid_202 == "50710718"
	replace unit_dist_205 = "30" if studentid_202 == "50710810"
	replace unit_dist_205 = "45" if studentid_202 == "50710811"
	replace unit_dist_205 = "20" if studentid_202 == "50710812"
	replace unit_dist_205 = "40" if studentid_202 == "50711110"
	replace unit_dist_205 = "5" if studentid_202 == "50711111"
	replace unit_dist_205 = "40" if studentid_202 == "50711112"
	replace unit_dist_205 = "40" if studentid_202 == "50711212"
	replace unit_dist_205 = "30" if studentid_202 == "50711213"
	replace unit_dist_205 = "50" if studentid_202 == "50711214"
	replace unit_dist_205 = "120" if studentid_202 == "50711215"
	replace unit_dist_205 = "45" if studentid_202 == "50711216"
	replace unit_dist_205 = "90" if studentid_202 == "50711217"
	replace unit_dist_205 = "100" if studentid_202 == "50711219"
	replace unit_dist_205 = "7" if studentid_202 == "50711221"
	replace unit_dist_205 = "40" if studentid_202 == "50711222"
	replace unit_dist_205 = "30" if studentid_202 == "50711224"
	replace unit_dist_205 = "90" if studentid_202 == "50711510"
	replace unit_dist_205 = "120" if studentid_202 == "50711812"
	replace unit_dist_205 = "120" if studentid_202 == "50711813"
	replace unit_dist_205 = "120" if studentid_202 == "50711818"
	replace unit_dist_205 = "75" if studentid_202 == "50711822"
	replace unit_dist_205 = "120" if studentid_202 == "50711823"
	replace unit_dist_205 = "30" if studentid_202 == "50712010"
	replace unit_dist_205 = "10" if studentid_202 == "50712014"
	replace unit_dist_205 = "40" if studentid_202 == "50712017"
	replace unit_dist_205 = "45" if studentid_202 == "50712019"
	replace unit_dist_205 = "30" if studentid_202 == "50712020"
	replace unit_dist_205 = "60" if studentid_202 == "50712117"
	replace unit_dist_205 = "5" if studentid_202 == "50712311"
	replace unit_dist_205 = "20" if studentid_202 == "50712314"
	replace unit_dist_205 = "15" if studentid_202 == "50712315"
	replace unit_dist_205 = "60" if studentid_202 == "50712316"
	replace unit_dist_205 = "90" if studentid_202 == "50712318"
	replace unit_dist_205 = "3" if studentid_202 == "70503411"
	replace unit_dist_205 = "50" if studentid_202 == "451913412"
	replace unit_dist_205 = "90" if studentid_202 == "451913413"
	replace unit_dist_205 = "70" if studentid_202 == "451913414"
	replace unit_dist_205 = "30" if studentid_202 == "451913416"
	replace unit_dist_205 = "15" if studentid_202 == "451913417"
	replace unit_dist_205 = "30" if studentid_202 == "451913418"
	replace unit_dist_205 = "25" if studentid_202 == "50712118"
	replace unit_dist_205 = "" if unit_dist_205 == "-99" | unit_dist_205 == "0"
	destring unit_dist_205, replace force
	

* Cleaning lasttime_expenses_410 question: "410. During the last  perdiod, this business had how much in profits?"
	replace lasttime_expenses_410 = "700" if studentid_202 == "451004"
	replace lasttime_expenses_410 = "3000" if studentid_202 == "451005"
	replace lasttime_expenses_410 = "50000" if studentid_202 == "451006"
	replace lasttime_expenses_410 = "5000" if studentid_202 == "451051"
	replace lasttime_expenses_410 = "" if studentid_202 == "4020112"
	replace lasttime_expenses_410 = "100000" if studentid_202 == "4510414"
	replace lasttime_expenses_410 = "1000" if studentid_202 == "4512622"
	replace lasttime_expenses_410 = "20000" if studentid_202 == "50712014"
	replace lasttime_expenses_410 = "" if lasttime_expenses_410 == "-99" | lasttime_expenses_410 == "0"
	destring lasttime_expenses_410, replace force

	
* Cleaning time_paidworker_411 question: "411. You said this business employed  people. How much were they paid to work during the last  period?"
	replace time_paidworker_411 = "16000" if studentid_202 == "451006"
	replace time_paidworker_411 = "1000" if studentid_202 == "451051"
	replace time_paidworker_411 = "1200" if studentid_202 == "451209"
	replace time_paidworker_411 = "14000" if studentid_202 == "5071154"
	replace time_paidworker_411 = "1500" if studentid_202 == "40111510"
	replace time_paidworker_411 = "" if studentid_202 == "50710216"
	replace time_paidworker_411 = "25000" if studentid_202 == "50711519"
	replace time_paidworker_411 = "" if time_paidworker_411 == "-99" | time_paidworker_411 == "0" | time_paidworker_411 == "-89"
	destring time_paidworker_411, replace force
	
	
* Cleaning destring aggr_506 question : "506. How did you score on your last promotional exam?"
	replace aggr_506 = "61" if studentid_202 == "450355"
	replace aggr_506 = "55" if studentid_202 == "451027"
	replace aggr_506 = "57" if studentid_202 == "451028"
	replace aggr_506 = "65" if studentid_202 == "451029"
	replace aggr_506 = "55" if studentid_202 == "451045"
	replace aggr_506 = "54" if studentid_202 == "451046"
	replace aggr_506 = "68" if studentid_202 == "451049"
	replace aggr_506 = "71" if studentid_202 == "451051"
	replace aggr_506 = "69" if studentid_202 == "451061"
	replace aggr_506 = "65" if studentid_202 == "451114"
	replace aggr_506 = "67" if studentid_202 == "451116"
	replace aggr_506 = "49" if studentid_202 == "451141"
	replace aggr_506 = "51" if studentid_202 == "451148"
	replace aggr_506 = "84" if studentid_202 == "451173"
	replace aggr_506 = "67" if studentid_202 == "451174"
	replace aggr_506 = "75" if studentid_202 == "451177"
	replace aggr_506 = "65" if studentid_202 == "451179"
	replace aggr_506 = "62" if studentid_202 == "451191"
	replace aggr_506 = "69" if studentid_202 == "451198"
	replace aggr_506 = "55" if studentid_202 == "451199"
	replace aggr_506 = "64" if studentid_202 == "451207"
	replace aggr_506 = "80" if studentid_202 == "451208"
	replace aggr_506 = "73" if studentid_202 == "451209"
	replace aggr_506 = "55" if studentid_202 == "451236"
	replace aggr_506 = "55" if studentid_202 == "451243"
	replace aggr_506 = "52" if studentid_202 == "451264"
	replace aggr_506 = "67" if studentid_202 == "451265"
	replace aggr_506 = "52" if studentid_202 == "451267"
	replace aggr_506 = "46" if studentid_202 == "451306"
	replace aggr_506 = "56.5" if studentid_202 == "451307"
	replace aggr_506 = "64" if studentid_202 == "451309"
	replace aggr_506 = "68.7" if studentid_202 == "451316"
	replace aggr_506 = "69" if studentid_202 == "451337"
	replace aggr_506 = "55" if studentid_202 == "451336"
	replace aggr_506 = "49" if studentid_202 == "451339"
	replace aggr_506 = "61" if studentid_202 == "4010146"
	replace aggr_506 = "75" if studentid_202 == "4010271"
	replace aggr_506 = "69" if studentid_202 == "4010272"
	replace aggr_506 = "78" if studentid_202 == "4010273"
	replace aggr_506 = "72" if studentid_202 == "4010274"
	replace aggr_506 = "60" if studentid_202 == "4010275"
	replace aggr_506 = "65" if studentid_202 == "4010277"
	replace aggr_506 = "86" if studentid_202 == "4010278"
	replace aggr_506 = "60" if studentid_202 == "4010307"
	replace aggr_506 = "65" if studentid_202 == "4010308"
	replace aggr_506 = "67" if studentid_202 == "4010309"
	replace aggr_506 = "68" if studentid_202 == "4010324"
	replace aggr_506 = "64" if studentid_202 == "4010327"
	replace aggr_506 = "81" if studentid_202 == "4010329"
	replace aggr_506 = "57" if studentid_202 == "4011151"
	replace aggr_506 = "85" if studentid_202 == "4011152"
	replace aggr_506 = "84" if studentid_202 == "4011153"
	replace aggr_506 = "57" if studentid_202 == "4011155"
	replace aggr_506 = "56" if studentid_202 == "4011265"
	replace aggr_506 = "62" if studentid_202 == "4011266"
	replace aggr_506 = "60" if studentid_202 == "4011332"
	replace aggr_506 = "66" if studentid_202 == "4011334"
	replace aggr_506 = "68" if studentid_202 == "4020115"
	replace aggr_506 = "69" if studentid_202 == "4020117"
	replace aggr_506 = "62" if studentid_202 == "4020119"
	replace aggr_506 = "59" if studentid_202 == "4020327"
	replace aggr_506 = "49" if studentid_202 == "4021031"
	replace aggr_506 = "78" if studentid_202 == "4021038"
	replace aggr_506 = "65" if studentid_202 == "4021039"
	replace aggr_506 = "65" if studentid_202 == "4021032"
	replace aggr_506 = "52" if studentid_202 == "4021096"
	replace aggr_506 = "56" if studentid_202 == "4021097"
	replace aggr_506 = "60" if studentid_202 == "4021098"
	replace aggr_506 = "78" if studentid_202 == "4021103"
	replace aggr_506 = "55" if studentid_202 == "4021111"
	replace aggr_506 = "65" if studentid_202 == "4021112"
	replace aggr_506 = "50" if studentid_202 == "4021116"
	replace aggr_506 = "70" if studentid_202 == "4021118"
	replace aggr_506 = "60" if studentid_202 == "4021167"
	replace aggr_506 = "54" if studentid_202 == "4021173"
	replace aggr_506 = "42" if studentid_202 == "4021177"
	replace aggr_506 = "52" if studentid_202 == "4030216"
	replace aggr_506 = "51" if studentid_202 == "4030218"
	replace aggr_506 = "66" if studentid_202 == "4030308"
	replace aggr_506 = "71" if studentid_202 == "4030309"
	replace aggr_506 = "56" if studentid_202 == "4030376"
	replace aggr_506 = "57" if studentid_202 == "4030378"
	replace aggr_506 = "57" if studentid_202 == "4030379"
	replace aggr_506 = "57" if studentid_202 == "4030573"
	replace aggr_506 = "57" if studentid_202 == "4030505"
	replace aggr_506 = "51" if studentid_202 == "4030503"
	replace aggr_506 = "69" if studentid_202 == "4030579"
	replace aggr_506 = "76" if studentid_202 == "4030574"
	replace aggr_506 = "57" if studentid_202 == "4031101"
	replace aggr_506 = "56" if studentid_202 == "4031102"
	replace aggr_506 = "52" if studentid_202 == "4031105"
	replace aggr_506 = "55" if studentid_202 == "4031107"
	replace aggr_506 = "58" if studentid_202 == "4031117"
	replace aggr_506 = "45" if studentid_202 == "4031126"
	replace aggr_506 = "45.4" if studentid_202 == "4031132"
	replace aggr_506 = "47" if studentid_202 == "4031133"
	replace aggr_506 = "50" if studentid_202 == "4031129"
	replace aggr_506 = "63" if studentid_202 == "4031211"
	replace aggr_506 = "58" if studentid_202 == "4031212"
	replace aggr_506 = "44" if studentid_202 == "4031214"
	replace aggr_506 = "79" if studentid_202 == "4031218"
	replace aggr_506 = "52" if studentid_202 == "4031231"
	replace aggr_506 = "53" if studentid_202 == "4031252"
	replace aggr_506 = "53" if studentid_202 == "4031235"
	replace aggr_506 = "59" if studentid_202 == "4031239"
	replace aggr_506 = "56.2" if studentid_202 == "4031256"
	replace aggr_506 = "75" if studentid_202 == "4031258"
	replace aggr_506 = "65" if studentid_202 == "4031259"
	replace aggr_506 = "53" if studentid_202 == "4031291"
	replace aggr_506 = "75" if studentid_202 == "4031292"
	replace aggr_506 = "78" if studentid_202 == "4031293"
	replace aggr_506 = "68" if studentid_202 == "4031295"
	replace aggr_506 = "62" if studentid_202 == "4150516"
	replace aggr_506 = "62" if studentid_202 == "4112621"
	replace aggr_506 = "67" if studentid_202 == "4510413"
	replace aggr_506 = "62" if studentid_202 == "4510414"
	replace aggr_506 = "61" if studentid_202 == "4510417"
	replace aggr_506 = "62" if studentid_202 == "4510418"
	replace aggr_506 = "69.5" if studentid_202 == "4510515"
	replace aggr_506 = "64" if studentid_202 == "4510610"
	replace aggr_506 = "72" if studentid_202 == "4510510"
	replace aggr_506 = "71" if studentid_202 == "4510612"
	replace aggr_506 = "65" if studentid_202 == "4510614"
	replace aggr_506 = "55" if studentid_202 == "4510615"
	replace aggr_506 = "73" if studentid_202 == "4510616"
	replace aggr_506 = "60" if studentid_202 == "4510617"
	replace aggr_506 = "64" if studentid_202 == "4511120"
	replace aggr_506 = "60" if studentid_202 == "4511413"
	replace aggr_506 = "64.5" if studentid_202 == "4511415"
	replace aggr_506 = "78" if studentid_202 == "4511711"
	replace aggr_506 = "65" if studentid_202 == "4511712"
	replace aggr_506 = "62" if studentid_202 == "4512012"
	replace aggr_506 = "64.3" if studentid_202 == "4512013"
	replace aggr_506 = "57" if studentid_202 == "4511912"
	replace aggr_506 = "61" if studentid_202 == "4512014"
	replace aggr_506 = "51" if studentid_202 == "4512311"
	replace aggr_506 = "61" if studentid_202 == "4512312"
	replace aggr_506 = "47" if studentid_202 == "4512314"
	replace aggr_506 = "74" if studentid_202 == "4512315"
	replace aggr_506 = "55" if studentid_202 == "4512316"
	replace aggr_506 = "58" if studentid_202 == "4512414"
	replace aggr_506 = "52" if studentid_202 == "4512415"
	replace aggr_506 = "49.8" if studentid_202 == "4512416"
	replace aggr_506 = "64" if studentid_202 == "4512419"
	replace aggr_506 = "67.5" if studentid_202 == "4512420"
	replace aggr_506 = "67" if studentid_202 == "4512610"
	replace aggr_506 = "54" if studentid_202 == "4512616"
	replace aggr_506 = "56" if studentid_202 == "4512618"
	replace aggr_506 = "53" if studentid_202 == "4512620"
	replace aggr_506 = "60" if studentid_202 == "4512622"
	replace aggr_506 = "89.5" if studentid_202 == "5070545"
	replace aggr_506 = "62" if studentid_202 == "4513314"
	replace aggr_506 = "68" if studentid_202 == "4513316"
	replace aggr_506 = "63" if studentid_202 == "4513323"
	replace aggr_506 = "55" if studentid_202 == "4513329"
	replace aggr_506 = "52" if studentid_202 == "4513610"
	replace aggr_506 = "69" if studentid_202 == "4513614"
	replace aggr_506 = "88" if studentid_202 == "5070552"
	replace aggr_506 = "83" if studentid_202 == "5070554"
	replace aggr_506 = "88" if studentid_202 == "5070557"
	replace aggr_506 = "85" if studentid_202 == "5070558"
	replace aggr_506 = "90" if studentid_202 == "5070559"
	replace aggr_506 = "63" if studentid_202 == "5071006"
	replace aggr_506 = "59" if studentid_202 == "5071022"
	replace aggr_506 = "58" if studentid_202 == "5071052"
	replace aggr_506 = "55" if studentid_202 == "5071053"
	replace aggr_506 = "64" if studentid_202 == "5071055"
	replace aggr_506 = "66.5" if studentid_202 == "5071116"
	replace aggr_506 = "52" if studentid_202 == "5071117"
	replace aggr_506 = "67" if studentid_202 == "5071118"
	replace aggr_506 = "66" if studentid_202 == "5071119"
	replace aggr_506 = "54" if studentid_202 == "5071127"
	replace aggr_506 = "62" if studentid_202 == "5071155"
	replace aggr_506 = "63" if studentid_202 == "5071158"
	replace aggr_506 = "53" if studentid_202 == "5071203"
	replace aggr_506 = "54" if studentid_202 == "5071205"
	replace aggr_506 = "69.2" if studentid_202 == "5071232"
	replace aggr_506 = "71.5" if studentid_202 == "5071235"
	replace aggr_506 = "62" if studentid_202 == "5071236"
	replace aggr_506 = "67" if studentid_202 == "5071238"
	replace aggr_506 = "65" if studentid_202 == "5071522"
	replace aggr_506 = "60" if studentid_202 == "7050345"
	replace aggr_506 = "61" if studentid_202 == "7050347"
	replace aggr_506 = "62.5" if studentid_202 == "7050349"
	replace aggr_506 = "55" if studentid_202 == "40101412"
	replace aggr_506 = "68" if studentid_202 == "40101414"
	replace aggr_506 = "71" if studentid_202 == "40101613"
	replace aggr_506 = "65" if studentid_202 == "40101614"
	replace aggr_506 = "79" if studentid_202 == "40101617"
	replace aggr_506 = "64" if studentid_202 == "40101619"
	replace aggr_506 = "70" if studentid_202 == "40102713"
	replace aggr_506 = "75" if studentid_202 == "40103213"
	replace aggr_506 = "57" if studentid_202 == "40111510"
	replace aggr_506 = "55" if studentid_202 == "40111511"
	replace aggr_506 = "62" if studentid_202 == "40112617"
	replace aggr_506 = "56" if studentid_202 == "40113310"
	replace aggr_506 = "68" if studentid_202 == "40113315"
	replace aggr_506 = "64" if studentid_202 == "40113318"
	replace aggr_506 = "78" if studentid_202 == "40113322"
	replace aggr_506 = "57" if studentid_202 == "40201113"
	replace aggr_506 = "64" if studentid_202 == "40203216"
	replace aggr_506 = "62.7" if studentid_202 == "40203218"
	replace aggr_506 = "63" if studentid_202 == "40203222"
	replace aggr_506 = "53" if studentid_202 == "40210313"
	replace aggr_506 = "81" if studentid_202 == "40210315"
	replace aggr_506 = "52" if studentid_202 == "40210319"
	replace aggr_506 = "60" if studentid_202 == "40210317"
	replace aggr_506 = "60.5" if studentid_202 == "40210916"
	replace aggr_506 = "71.5" if studentid_202 == "40211018"
	replace aggr_506 = "70.5" if studentid_202 == "40210918"
	replace aggr_506 = "65" if studentid_202 == "40211019"
	replace aggr_506 = "72" if studentid_202 == "40211020"
	replace aggr_506 = "63" if studentid_202 == "40211114"
	replace aggr_506 = "62" if studentid_202 == "40211115"
	replace aggr_506 = "70" if studentid_202 == "40211117"
	replace aggr_506 = "52.2" if studentid_202 == "40211616"
	replace aggr_506 = "58" if studentid_202 == "40211615"
	replace aggr_506 = "52" if studentid_202 == "40211713"
	replace aggr_506 = "69" if studentid_202 == "40211712"
	replace aggr_506 = "54" if studentid_202 == "40211715"
	replace aggr_506 = "50" if studentid_202 == "40211717"
	replace aggr_506 = "65" if studentid_202 == "40211716"
	replace aggr_506 = "45" if studentid_202 == "40211718"
	replace aggr_506 = "52" if studentid_202 == "40302110"
	replace aggr_506 = "58" if studentid_202 == "40302114"
	replace aggr_506 = "63" if studentid_202 == "40303017"
	replace aggr_506 = "56" if studentid_202 == "40303711"
	replace aggr_506 = "63" if studentid_202 == "40303713"
	replace aggr_506 = "54" if studentid_202 == "40303715"
	replace aggr_506 = "60" if studentid_202 == "40303716"
	replace aggr_506 = "62" if studentid_202 == "40303729"
	replace aggr_506 = "62" if studentid_202 == "40305010"
	replace aggr_506 = "50" if studentid_202 == "40305016"
	replace aggr_506 = "62" if studentid_202 == "40305712"
	replace aggr_506 = "58" if studentid_202 == "40311113"
	replace aggr_506 = "51" if studentid_202 == "40311114"
	replace aggr_506 = "47" if studentid_202 == "40311116"
	replace aggr_506 = "63" if studentid_202 == "40311119"
	replace aggr_506 = "47" if studentid_202 == "40311317"
	replace aggr_506 = "55" if studentid_202 == "40311013"
	replace aggr_506 = "62" if studentid_202 == "40311319"
	replace aggr_506 = "53" if studentid_202 == "40311320"
	replace aggr_506 = "53" if studentid_202 == "40312116"
	replace aggr_506 = "48" if studentid_202 == "40312117"
	replace aggr_506 = "74" if studentid_202 == "40312118"
	replace aggr_506 = "62" if studentid_202 == "40312121"
	replace aggr_506 = "58" if studentid_202 == "40312312"
	replace aggr_506 = "57" if studentid_202 == "40312320"
	replace aggr_506 = "49" if studentid_202 == "40312321"
	replace aggr_506 = "58" if studentid_202 == "40312510"
	replace aggr_506 = "53" if studentid_202 == "40312512"
	replace aggr_506 = "66" if studentid_202 == "40312513"
	replace aggr_506 = "50" if studentid_202 == "40312516"
	replace aggr_506 = "86" if studentid_202 == "40312910"
	replace aggr_506 = "75" if studentid_202 == "40312912"
	replace aggr_506 = "55.18" if studentid_202 == "40313212"
	replace aggr_506 = "87" if studentid_202 == "40312917"
	replace aggr_506 = "56" if studentid_202 == "40312910"
	replace aggr_506 = "56" if studentid_202 == "45191342"
	replace aggr_506 = "58" if studentid_202 == "45191343"
	replace aggr_506 = "58" if studentid_202 == "50703419"
	replace aggr_506 = "61" if studentid_202 == "50703420"
	replace aggr_506 = "82.7" if studentid_202 == "50705416"
	replace aggr_506 = "73" if studentid_202 == "50705417"
	replace aggr_506 = "85" if studentid_202 == "50705418"
	replace aggr_506 = "87" if studentid_202 == "50705515"
	replace aggr_506 = "88" if studentid_202 == "50705519"
	replace aggr_506 = "56" if studentid_202 == "50710010"
	replace aggr_506 = "67" if studentid_202 == "50710018"
	replace aggr_506 = "58" if studentid_202 == "50710019"
	replace aggr_506 = "72" if studentid_202 == "50710213"
	replace aggr_506 = "78" if studentid_202 == "50710214"
	replace aggr_506 = "49" if studentid_202 == "50710215"
	replace aggr_506 = "63" if studentid_202 == "50710418"
	replace aggr_506 = "60" if studentid_202 == "50710419"
	replace aggr_506 = "58" if studentid_202 == "50710420"
	replace aggr_506 = "55.18" if studentid_202 == "50710513"
	replace aggr_506 = "71" if studentid_202 == "50710514"
	replace aggr_506 = "44.9" if studentid_202 == "50711212"
	replace aggr_506 = "72" if studentid_202 == "50711217"
	replace aggr_506 = "69" if studentid_202 == "50711510"
	replace aggr_506 = "43" if studentid_202 == "50711221"
	replace aggr_506 = "64" if studentid_202 == "50712014"
	replace aggr_506 = "44" if studentid_202 == "50712017"
	replace aggr_506 = "50" if studentid_202 == "50712019"
	replace aggr_506 = "54" if studentid_202 == "50712010"
	replace aggr_506 = "66" if studentid_202 == "50712020"
	replace aggr_506 = "75.3" if studentid_202 == "50712311"
	replace aggr_506 = "78" if studentid_202 == "50712314"
	replace aggr_506 = "70" if studentid_202 == "50712315"
	replace aggr_506 = "78" if studentid_202 == "50712316"
	replace aggr_506 = "68" if studentid_202 == "50712318"
	replace aggr_506 = "75" if studentid_202 == "70503411"
	replace aggr_506 = "53" if studentid_202 == "70503412"
	replace aggr_506 = "54.5" if studentid_202 == "451913411"
	replace aggr_506 = "62.4" if studentid_202 == "50712318"
	replace aggr_506 = "62.4" if studentid_202 == "451913412"
	replace aggr_506 = "53" if studentid_202 == "451913413"
	replace aggr_506 = "54" if studentid_202 == "451913414"
	replace aggr_506 = "51" if studentid_202 == "451913418"

	*replace aggr_506 = "" if aggr_506 == "_99" | aggr_506 == "-99"
	replace aggr_506 = "-99" if aggr_506 == "_99"

	destring aggr_506, replace force


* Cleaning the question busi_activ_408 : "408. Has this business done any of the following activities?"
	destring busi_activ_408_other, replace
	replace busi_activ_408_i = 1 if busi_activ_408_other == 1
	replace busi_activ_408_ii = 2 if busi_activ_408_other == 2
	replace busi_activ_408_iii = 3 if busi_activ_408_other == 3

	label variable busi_activ_408_i "408. Has this business done any of the following activities?"
	label define busi_activ_408_ilab 1 "Yes" 0 "No"
	label values busi_activ_408_i busi_activ_408_ilab
	  
	label variable busi_activ_408_ii "408. Has this business done any of the following activities?"
	label define busi_activ_408_iilab 1 "Yes" 0 "No"
	label values busi_activ_408_ii busi_activ_408_iilab

	label variable busi_activ_408_iii "408. Has this business done any of the following activities?"
	label define busi_activ_408_iiilab 1 "Yes" 0 "No"
	label values busi_activ_408_iii busi_activ_408_iiilab

	label variable busi_activ_408_iv "408. Has this business done any of the following activities?"
	label define busi_activ_408_ivlab 1 "Yes" 0 "No"
	label values busi_activ_408_iv busi_activ_408_ivlab

	label variable busi_activ_408_v "408. Has this business done any of the following activities?"
	label define busi_activ_408_vlab 1 "Yes" 0 "No"
	label values busi_activ_408_v busi_activ_408_vlab

	label variable busi_activ_408__99 "408. Has this business done any of the following activities?"
	label define busi_activ_408__99lab 1 "Yes" 0 "No"
	label values busi_activ_408__99 busi_activ_408__99lab

	label variable busi_activ_408_vii "408. Has this business done any of the following activities?"
	label define busi_activ_408_viilab 1 "Yes" 0 "No"
	label values busi_activ_408_vii busi_activ_408_viilab

	label variable busi_activ_408_viii "408. Has this business done any of the following activities?"
	label define busi_activ_408_viiilab 1 "Yes" 0 "No"
	label values busi_activ_408_viii busi_activ_408_viiilab


	/*
		drop busi_activ_408_other
		
		tostring studentid_202, replace
		replace busi_activ_408 = "i" if studentid_202 == "451121" & busi_activ_408 == "viii"
		
		
		
		#delimit ;
		label def busi_activ_408
		ix "Marketing(product, service,..)"
		, add
		;
		#delimit cr
		
		drop busi_activ_408_other
	*/

* Cleaning raise_money_413 question : "413. How did the business raise money or assets (goat, land bees, etc) to start?"

	destring raise_money_other_413, replace force
	replace raise_money_413_1 = 1 if raise_money_other_413 == 1
	replace raise_money_413_2 = 1 if raise_money_other_413 == 2
	replace raise_money_413_3 = 1 if raise_money_other_413 == 3
	replace raise_money_413_4 = 1 if raise_money_other_413 == 4
	replace raise_money_413_5 = 1 if raise_money_other_413 == 5
	replace raise_money_413_6 = 1 if raise_money_other_413 == 6
	replace raise_money_413_7 = 1 if raise_money_other_413 == 7
	replace raise_money_413_8 = 1 if raise_money_other_413 == 8


	label variable raise_money_413_1 "413. How did the business raise money or assets (goat, land bees, etc) to start?"
	label define moth_fath_guardian 1 "Yes" 0 "No"
	label values raise_money_413_1 moth_fath_guardian

	label variable raise_money_413_2 "413. How did the business raise money or assets (goat, land bees, etc) to start?"
	label define broth_sist_cousin 1 "Yes" 0 "No"
	label values raise_money_413_2 broth_sist_cousin

	label variable raise_money_413_3 "413. How did the business raise money or assets (goat, land bees, etc) to start?"
	label define profits_busi_club 1 "Yes" 0 "No"
	label values raise_money_413_3 profits_busi_club

	label variable raise_money_413_4 "413. How did the business raise money or assets (goat, land bees, etc) to start?"
	label define diff_fam_member 1 "Yes" 0 "No"
	label values raise_money_413_4 diff_fam_member

	label variable raise_money_413_5 "413. How did the business raise money or assets (goat, land bees, etc) to start?"
	label define friends 1 "Yes" 0 "No"
	label values raise_money_413_5 friends

	label variable raise_money_413_6 "413. How did the business raise money or assets (goat, land bees, etc) to start?"
	label define church_templ_mosque 1 "Yes" 0 "No"
	label values raise_money_413_6 church_templ_mosque

	label variable raise_money_413_7 "413. How did the business raise money or assets (goat, land bees, etc) to start?"
	label define someone_else 1 "Yes" 0 "No"
	label values raise_money_413_7 someone_else

	label variable raise_money_413_8 "413. How did the business raise money or assets (goat, land bees, etc) to start?"
	label define raised_mon_myself 1 "Yes" 0 "No"
	label values raise_money_413_8 raised_mon_myself

	label variable raise_money_413_9 "413. How did the business raise money or assets (goat, land bees, etc) to start?"
	label define other 1 "Other" 0 "No"
	label values raise_money_413_9 other

	drop raise_money_413_9 raise_money_other_413	


* Cleaning whenhome_429 question
	label variable whenhome_429_1 "425. When at home, which of the following activities do you do on a regular basis"
	label define whenhome_429_1lab 1 "Yes" 0 "No"
	label values whenhome_429_1 whenhome_429_1lab

	label variable whenhome_429_2 "425. When at home, which of the following activities do you do on a regular basis"
	label define whenhome_429_2lab 1 "Yes" 0 "No"
	label values whenhome_429_2 whenhome_429_2lab

	label variable whenhome_429_3 "425. When at home, which of the following activities do you do on a regular basis"
	label define whenhome_429_3lab 1 "Yes" 0 "No"
	label values whenhome_429_3 whenhome_429_3lab

	label variable whenhome_429_4 "425. When at home, which of the following activities do you do on a regular basis"
	label define whenhome_429_4lab 1 "Yes" 0 "No"
	label values whenhome_429_4 whenhome_429_4lab

	label variable whenhome_429_5 "425. When at home, which of the following activities do you do on a regular basis"
	label define whenhome_429_5lab 1 "Yes" 0 "No"
	label values whenhome_429_5 whenhome_429_5lab

	label variable whenhome_429_6 "425. When at home, which of the following activities do you do on a regular basis"
	label define whenhome_429_6lab 1 "Yes" 0 "No"
	label values whenhome_429_6 whenhome_429_6lab

	label variable whenhome_429_7 "425. When at home, which of the following activities do you do on a regular basis"
	label define whenhome_429_7lab 1 "Yes" 0 "No"
	label values whenhome_429_7 whenhome_429_7lab

	label variable whenhome_429_8 "425. When at home, which of the following activities do you do on a regular basis"
	label define whenhome_429_8lab 1 "Yes" 0 "No"
	label values whenhome_429_8 whenhome_429_8lab

	label variable whenhome_429_9 "425. When at home, which of the following activities do you do on a regular basis"
	label define whenhome_429_9lab 1 "Yes" 0 "No"
	label values whenhome_429_9 whenhome_429_9lab

 
* Cleaning assets_306 question
	label variable assets_306_a "306. Do you have any of the following assets in your house?"
	label define assets_306_alab 1 "Yes" 0 "No"
	label values assets_306_a assets_306_alab

	label variable assets_306_b "306. Do you have any of the following assets in your house?"
	label define assets_306_blab 1 "Yes" 0 "No"
	label values assets_306_b assets_306_blab

	label variable assets_306_c "306. Do you have any of the following assets in your house?"
	label define assets_306_clab 1 "Yes" 0 "No"
	label values assets_306_c assets_306_clab

	label variable assets_306_d "306. Do you have any of the following assets in your house?"
	label define assets_306_dlab 1 "Yes" 0 "No"
	label values assets_306_c assets_306_dlab

	label variable assets_306_e "306. Do you have any of the following assets in your house?"
	label define assets_306_elab 1 "Yes" 0 "No"
	label values assets_306_e assets_306_elab

	label variable assets_306_f "306. Do you have any of the following assets in your house?"
	label define assets_306_flab 1 "Yes" 0 "No"
	label values assets_306_f assets_306_flab

	label variable assets_306_g "306. Do you have any of the following assets in your house?"
	label define assets_306_glab 1 "Yes" 0 "No"
	label values assets_306_g assets_306_glab

	label variable assets_306_h "306. Do you have any of the following assets in your house?"
	label define assets_306_hlab 1 "Yes" 0 "No"
	label values assets_306_h assets_306_hlab


* Drop often_paid_414_label_1 as it was cleaned from oftenpaid_414_1
	drop often_paid_414_label_1

 * Cleaning earn_receive_401 question
	replace howmuch_415_1 = "4500" if studentid_202 == "451177"
	replace howmuch_415_1 = "3000" if studentid_202 == "451194"
	replace howmuch_415_1 = "4000" if studentid_202 == "451265"
	replace howmuch_415_1 = "2000" if studentid_202 == "4011231"
	replace howmuch_415_1 = "3872" if studentid_202 == "4011265"
	replace howmuch_415_1 = "33440" if studentid_202 == "4011266"
	replace howmuch_415_1 = "3520" if studentid_202 == "4031117"
	replace howmuch_415_1 = "1000" if studentid_202 == "4031259"
	replace howmuch_415_1 = "10560" if studentid_202 == "4112621"
	replace howmuch_415_1 = "1000" if studentid_202 == "4513915"
	replace howmuch_415_1 = "880" if studentid_202 == "5071052"
	replace howmuch_415_1 = "15000" if studentid_202 == "40112310"
	replace howmuch_415_1 = "1000" if studentid_202 == "40212119"
	replace howmuch_415_1 = "4400" if studentid_202 == "50710018"
	replace howmuch_415_1 = "2500" if studentid_202 == "50712316"
	replace howmuch_415_1 = "500" if studentid_202 == "451913414"

	replace howmuch_415_1 = "" if howmuch_415_1 == "_99" | howmuch_415_1 == "0"
	destring howmuch_415_1, replace force
	
	
* Converting roman letters into string numbers for the question : type_busi_407 that needed to be labelled
	replace  type_busi_407 = "1" if  type_busi_407 == "i"
	replace  type_busi_407 = "2" if  type_busi_407 == "ii"
	replace  type_busi_407 = "3" if  type_busi_407 == "iii"
	replace  type_busi_407 = "4" if  type_busi_407 == "iv"
	replace  type_busi_407 = "5" if  type_busi_407 == "v"
	replace  type_busi_407 = "6" if  type_busi_407 == "vi"
	replace  type_busi_407 = "7" if  type_busi_407 == "vii"
	replace  type_busi_407 = "8" if  type_busi_407 == "ix"
	replace  type_busi_407 = "9" if  type_busi_407 == "x"
	replace  type_busi_407 = "10" if  type_busi_407 == "xi"

	destring type_busi_407, replace
	label define type_busi_407lab 1 "Farming/Livestock" ///
	2 "Art, jewellery or craft/ making/selling" ///
	3 "Food making/food selling business" ///
	4 "Household product making/selling (like liquid soap or candles)" ///
	5 "Shop that buys and resells products" ///
	6 "Salon/hairdressing" ///
	7 "Small shop" ///
	8 "ICT/Computer buying/selling/repair shop" ///
	9 "Skilled Trade (construction, tailoring, carpentry)" ///
	10 "Other"
	label values type_busi_407 type_busi_407lab


* Cleaning  whosupp_701 question: "701. Who supports students in running the student business club?"
	la var whosupp_701_1 "701. Who supports students in running the student business club?"
	lab de Entrep_teacher 1 "Yes" 0 "No"
	la values whosupp_701_1 Entrep_teacher
	 
	la var whosupp_701_2 "701. Who supports students in running the student business club?"
	lab de Other_teacher 1 "Yes" 0 "No"
	la values whosupp_701_2 Other_teacher
	 
	la var whosupp_701_3 "701. Who supports students in running the student business club?"
	lab de Head_teacher 1 "Yes" 0 "No"
	la values whosupp_701_3 Head_teacher
	 
	la var whosupp_701_4 "701. Who supports students in running the student business club?"
	lab de Parents 1 "Yes" 0 "No"
	la values whosupp_701_4 Parents
	 
	la var whosupp_701_5 "701. Who supports students in running the student business club?"
	lab de Another_entrepreneur 1 "Yes" 0 "No"
	la values whosupp_701_5 Another_entrepreneur

	la var whosupp_701_6 "701. Who supports students in running the student business club?"
	lab de Other_school_official  1 "Yes" 0 "No"
	la values whosupp_701_6 Other_school_official 
	 
	la var whosupp_701_7 "701. Who supports students in running the student business club?"
	lab de None 1 "Yes" 0 "No"
	la values whosupp_701_7 None 	
 
 
* Cleaning typesupp_702 "702. What type of support does the entrepreneurship teacher provide student business club?"
	destring typesupp_702_other, replace
	destring  v301, replace
	replace typesupp_702_1 = 1 if v301 == 1
	replace typesupp_702_2 = 1 if v301 == 2
	replace typesupp_702_3 = 1 if v301 == 3
	replace typesupp_702_4 = 1 if v301 == 4
	replace typesupp_702_5 = 1 if v301 == 5
	replace typesupp_702_6 = 1 if v301 == 6
	replace typesupp_702_7 = 1 if v301 == 7	
	replace typesupp_702_other = 1 if v301 == -99	

	la var typesupp_702_1 "702. What type of support does the entrepreneurship teacher provide student business club?"
	la de Advises_club_leadership 1 "Yes" 0 "No"
	la values typesupp_702_1 Advises_club_leadership

	la var typesupp_702_2 "702. What type of support does the entrepreneurship teacher provide student business club?"
	la de Attended_1_meeting 1 "Yes" 0 "No"
	la values typesupp_702_2 Attended_1_meeting

	la var typesupp_702_3 "702. What type of support does the entrepreneurship teacher provide student business club?"
	la de Attends_meetings 1 "Yes" 0 "No"
	la values typesupp_702_3 Attends_meetings

	la var typesupp_702_4 "702. What type of support does the entrepreneurship teacher provide student business club?"
	la de Advises_challenges 1 "Yes" 0 "No"
	la values typesupp_702_4 Advises_challenges

	la var typesupp_702_5 "702. What type of support does the entrepreneurship teacher provide student business club?"
	la de Manages_club_funds 1 "Yes" 0 "No"
	la values typesupp_702_5 Manages_club_funds

	la var typesupp_702_5 "702. What type of support does the entrepreneurship teacher provide student business club?"
	la de none_lab 1 "Yes" 0 "No"
	la values typesupp_702_5 none_lab

	la var typesupp_702_6 "702. What type of support does the entrepreneurship teacher provide student business club?"
	la de typesupp_702_6lab 1 "Yes" 0 "No"
	la values typesupp_702_6 typesupp_702_6lab

	la var typesupp_702_7 "702. What type of support does the entrepreneurship teacher provide student business club?"
	la de typesupp_702_7lab 1 "Yes" 0 "No"
	la values typesupp_702_7 typesupp_702_7lab

	la var typesupp_702_other "702. What type of support does the entrepreneurship teacher provide student business club?"
	la de typesupp_702_otherlab 1 "Yes" 0 "No"
	la values typesupp_702_other typesupp_702_otherlab
	drop v301	

* Cleaning fromwgom_707question : "707. From whom did you learn?"
	la var fromwgom_707_1 "707. From whom did you learn?"
	la de Entrepren_teacher 1 "Yes" 0 "No"
	la values fromwgom_707_1 Entrepren_teacher

	la var fromwgom_707_2 "707. From whom did you learn?"
	la de Fellow_students 1 "Yes" 0 "No"
	la values fromwgom_707_2 Fellow_students

	la var fromwgom_707_3 "707. From whom did you learn?"
	la values fromwgom_707_3 Parents

	la var fromwgom_707_4 "707. From whom did you learn?"
	la values fromwgom_707_4 Another_entrepreneur

	la var fromwgom_707_5 "707. From whom did you learn?"
	la values fromwgom_707_5 other	
	

	
* Cleaning savedmon_804 question : "804. Do you have any money saved right now?"
	la var savedmon_804_1 "804. Do you have any money saved right now?"
	la def no_savings 1 "Yes" 0 "No"
	la values savedmon_804_1 no_savings

	la var savedmon_804_2 "804. Do you have any money saved right now?"
	la def hidden_box_drawer 1 "Yes" 0 "No"
	la values savedmon_804_2 hidden_box_drawer

	la var savedmon_804_3 "804. Do you have any money saved right now?"
	la def another_person_holds 1 "Yes" 0 "No"
	la values savedmon_804_3 another_person_holds

	la var savedmon_804_4 "804. Do you have any money saved right now?"
	la def group_account 1 "Yes" 0 "No"
	la values savedmon_804_4 group_account

	la var savedmon_804_5 "804. Do you have any money saved right now?"
	la def individ_account 1 "Yes" 0 "No"
	la values savedmon_804_5 individ_account

	la var savedmon_804_6 "804. Do you have any money saved right now?"
	la def SACCO_account 1 "Yes" 0 "No"
	la values savedmon_804_6 SACCO_account

	la var savedmon_804_7 "804. Do you have any money saved right now?"
	la def phone_account 1 "Yes" 0 "No"
	la values savedmon_804_7 phone_account

	la var savedmon_804__66 "804. Do you have any money saved right now?"
	la def savedmon_804__66other 1 "Yes" 0 "No"
	la values savedmon_804__66 savedmon_804__66other


* Cleaning incrproft_903 question : "901. In the above example from question 900, how would you be able to increase this monthly profit?"
	la var incrproft_903_1 "901. In the above example from question 900, how would you be able to increase this monthly profit?"
	la de Sell_more_bags 1 "Yes" 0 "No"
	la values incrproft_903_1 Sell_more_bags

	la var incrproft_903_2 "901. In the above example from question 900, how would you be able to increase this monthly profit?"
	la de increase_price 1 "Yes" 0 "No"
	la values incrproft_903_2 increase_price

	la var incrproft_903_3 "901. In the above example from question 900, how would you be able to increase this monthly profit?"
	la de Employ_someone 1 "Yes" 0 "No"
	la values incrproft_903_3 Employ_someone

	la var incrproft_903_4 "901. In the above example from question 900, how would you be able to increase this monthly profit?"
	la de Use_cheap_materials 1 "Yes" 0 "No"
	la values incrproft_903_4 Use_cheap_materials

	la var incrproft_903__66 "901. In the above example from question 900, how would you be able to increase this monthly profit?"
	la de Other 1 "Yes" 0 "No"
	la values incrproft_903__66 Other

	la var incrproft_903__55 "901. In the above example from question 900, how would you be able to increase this monthly profit?"
	la de Don_not_know 1 "Yes" 0 "No"
	la values incrproft_903__55 Don_not_know


* Cleaning growthindic_904 question : "902. Which of the following is NOT considered an indicator of business growth?"
	la var growthindic_904_1 "902. Which of the following is NOT considered an indicator of business growth?"
	la de Increase_sales 1 "Yes" 0 "No"
	la values growthindic_904_1 Increase_sales

	la var growthindic_904_2 "902. Which of the following is NOT considered an indicator of business growth?"
	la de Increase_profits 1 "Yes" 0 "No"
	la values growthindic_904_2 Increase_profits

	la var growthindic_904_3 "902. Which of the following is NOT considered an indicator of business growth?"
	la de Increase_liq_assets 1 "Yes" 0 "No"
	la values growthindic_904_3 Increase_liq_assets

	la var growthindic_904_4 "902. Which of the following is NOT considered an indicator of business growth?"
	la de Increase_liabilities 1 "Yes" 0 "No"
	la values growthindic_904_4 Increase_liabilities

	la var growthindic_904_5 "902. Which of the following is NOT considered an indicator of business growth?"
	la de Increase_market_share 1 "Yes" 0 "No"
	la values growthindic_904_5 Increase_market_share

	la var growthindic_904__66 "902. Which of the following is NOT considered an indicator of business growth?"
	la values growthindic_904__66 Other

	la var growthindic_904__99 "902. Which of the following is NOT considered an indicator of business growth?"
	la de Do_not_know 1 "Yes" 0 "No"
	la values growthindic_904__99 Do_not_know


* Cleaning solveproblm_1105 question : "1104. Many students are concerned about the problems in their school or community. Have you done anything to solve or raise awareness about these problems? Tick all of the activities you did"

	la var solveproblm_1105_1 "1104. Many students are concerned about the problems in their school or community. Have you done anything to solve or raise awareness about these problems? Tick all of the activities you did"
	la de have_not 1 "Yes" 0 "No"
	la values solveproblm_1105_1 have_not

	la var solveproblm_1105_2 "1104. Many students are concerned about the problems in their school or community. Have you done anything to solve or raise awareness about these problems? Tick all of the activities you did"
	la de started_comm_proj 1 "Yes" 0 "No"
	la values solveproblm_1105_2 started_comm_proj

	la var solveproblm_1105_3 "1104. Many students are concerned about the problems in their school or community. Have you done anything to solve or raise awareness about these problems? Tick all of the activities you did"
	la de talked_friends_classmat 1 "Yes" 0 "No"
	la values solveproblm_1105_3 talked_friends_classmat

	la var solveproblm_1105_4 "1104. Many students are concerned about the problems in their school or community. Have you done anything to solve or raise awareness about these problems? Tick all of the activities you did"
	la de started_club_awareness 1 "Yes" 0 "No"
	la values solveproblm_1105_4 started_club_awareness

	la var solveproblm_1105_5 "1104. Many students are concerned about the problems in their school or community. Have you done anything to solve or raise awareness about these problems? Tick all of the activities you did"
	la de joined_club 1 "Yes" 0 "No"
	la values solveproblm_1105_5 joined_club

	la var solveproblm_1105_6 "1104. Many students are concerned about the problems in their school or community. Have you done anything to solve or raise awareness about these problems? Tick all of the activities you did"
	la de organized_awareness 1 "Yes" 0 "No"
	la values solveproblm_1105_6 organized_awareness

	la var solveproblm_1105_7 "1104. Many students are concerned about the problems in their school or community. Have you done anything to solve or raise awareness about these problems? Tick all of the activities you did"
	la de did_someth_else 1 "Yes" 0 "No"
	la values solveproblm_1105_7 did_someth_else
	
	
* Labelling question why_1201
	destring why_1201, replace
	label define why_1201lab 1	"Because I might NOT get high enough points" ///
		2 "Because I WILL get high enough points" ///
		3 "Because I might NOT have the money" ///
		4 "Because I WILL have the money" ///
		5 "Because I don’t want to attend" ///
		6 "Because I will marry or start a family instead"
	label values why_1201 why_1201lab
	drop why_1201_other
	
	
* Labelling question why_1203
	destring why_1203, replace
	label define why_1203lab 1 "Because my PARENTS decide this" ///
		2 "Because my parents and I decide TOGETHER" ///
		3 "Because I decide this ALONE"
	label values why_1203 why_1203lab
	drop why_1203_other
	
	
* Labelling question why_1206_other
	destring why_1206, replace
	label define why_1206lab 1 "Because GOD will decide this" ///
		2 "Because I WILL use family planning" ///
		3 "Because my spouse will decide" ///
		4 "Because my spouse and I will decide together"
	label values why_1206 why_1206lab
	drop why_1206_other
	
	
* Labelling question why_1207_other
	destring why_1207, replace
	label define why_1207lab 1 "Because someone else might be more popular or qualified for the position" ///
		2 "Because I am popular; many people like me" ///
		3 "Because I am good at mobilizing people" ///
		4 "Because I am very qualified for this position"

	label values why_1207 why_1207lab
	drop why_1207_other
	
* Labelling question why_1209
	destring why_1209, replace
	la de why_1209lab 1 "Because there are some dangerous people" ///
	2 "Because I can protect myself" ///
	3 "Because the area is safe"
	la values why_1209 why_1209lab
	drop why_1209_other	
	
	

**This variable: enum_comments can be dropped as it has no useful information
*drop enum_comments

* Cleaning and merging english translations for the question project_want1003 to the main data set
	merge 1:1 studentid_202 using "project_want1003_trans.dta"
	*save "merged.dta", replace

	drop project_want1003
	la variable project_want1003_trans "1003. Suppose you have saved 100,000 RFW and you can use it to start ANY project you want! What type of project do you want to start? What you sell?"
	drop _merge
	rename project_want1003_trans project_want1003
	order project_want1003, after(busnsftr_1002)
	
	**dropped the following variable as it has no observations
	drop busnsftr_1002_other


	drop make_product_other_706
	label variable make_product_other_706_trans "706. What product did you learn how to make at school?"
	rename make_product_other_706_trans make_product_other_706
	order make_product_other_706, after(make_product_706_6)


	drop area_activities_312c
	la variable area_activities_312c_trans "312. c. What is the area of activity?"
	rename area_activities_312c_trans area_activities_312c
	order area_activities_312c, after(number_paid_312b)
		

	replace large_project_1102 = 3 if large_project_1102 == 4
	#delimit ;
		label def large_project_1102
		3 "A club / group to teach people about a problem/issue. The problem/issue"
		6 "A project of giving livestock to other community members"
		7 "A village saving & lending association(VSLA)"
		8 "Teaching of food crop farming"
		9 "n/a"
		, add
		;
	#delimit cr
		
	drop large_project_other_1102
	
	
	**=====================================================**
	*Other cleanings for appending the endline dataset to the tracking dataset
	
	**droping below varaibles aleardy corrected
	drop enumname_other village_202_other parents_other_302 roof_house_other_304 ///
		cook_other_307 fromwgom_707_5
	
	**generating missing varibales for the geolocations into the main student dataset
	**for appending purposes
	
	gen locationlatitude = .
	order locationlatitude locationlatitude, after(time_interview)
	la var locationlatitude "GPS coordinates of respondent'slocation (latitude)"
	
	gen locationlongitude = .
	order locationlongitude, after(locationlatitude)
	la var locationlongitude "GPS coordinates of respondent'slocation (longitude)"
	
	gen locationaltitude = .
	order locationaltitude, after(locationlongitude)
	la var locationaltitude "GPS coordinates of respondent'slocation (altitude)"
	
	gen locationaccuracy =.
	order locationaccuracy, after(locationaltitude)
	la var locationaccuracy "GPS coordinates of respondent'slocation (accuracy)"
	
	gen loc_success =.
	order loc_success, after(locationaccuracy)
	la var loc_success "Were you able to successfully collect the GPS coordinates?"
	
	gen dropout = 0
	la var dropout "Is the student you are about to interview a dropout ?"
	la def dropoutlab 1 "Yes" 0 "No"
	la values dropout dropoutlab
	order dropout, afte(consent)
	

	gen class_dropout = .
	order class_dropout, before(urban_rural_202)
	
	gen dropout_period = .
	order dropout_period, before(class_dropout)
	
	
	gen make_product_706_7 = .
	order make_product_706_7, after(make_product_706_6)
		
    gen make_product_706_8 = .
	order make_product_706_8, after(make_product_706_7)
	
	gen make_product_706_9 = .
	order make_product_706_9, after(make_product_706_8)
	
	gen make_product_706_10 = .
	order make_product_706_10, after(make_product_706_9)
	
	gen make_product_706_11 = .
	order make_product_706_11,after(make_product_706_10)
	
	gen make_product_706_12 = .
	order make_product_706_12, after(make_product_706_11)
	
    gen make_product_706_13 = .
	order make_product_706_13, after(make_product_706_12)
	
	gen make_product_706_14 = .
	order make_product_706_14, after(make_product_706_13)
	
	/*
	gen make_product_706_15 = .
	order make_product_706_15, after(make_product_706_14)
	*/

	gen savedmon_804_8 = .
	order savedmon_804_8, after(savedmon_804_7)
	
	gen savedmon_804_9 = .
	order savedmon_804_9, after(savedmon_804_8)
	
	
	gen follow_up = .
	la var follow_up "We are interested in learning about what you do after you finish secondary.  We will contact you next year to find out how you did your exams.  Is that alright?/"
	
	gen mop_up = .
	la var mop_up "Is this a mop up survey?"
	
	gen schoolid_old = ""
	order schoolid_old, after(family_name_200)
	
	gen confirm_studentid = .
	la var confirm_studentid "Ask the respondent if his/her name is ${student_name} from ${district_name} Di"
	
	drop typesupp_702_other
	
	*****************************************************************
	*Ordering variables newly created to match the tracking survey for appending purposes
	order confirm_studentid, after(class_dropout)
	order follow_up, after(newproj_1303)
	order mop_up, before(enum_comments)
	*order , after()
	*order , after()
	
		destring studentid_202, replace
	
	//correcting class_500 variable
	//To match it with the tracking dataset we neet to generate a new variable
	
tab class_500
label list class_500
gen class_corr = 1 if class_500 == 3
tab class_corr
replace class_corr = 3 if class_500 == 1
replace class_corr = 2 if class_500 == 2
replace class_corr = 4 if class_500 == .
tab class_corr
label var class_corr "Current class level"
la de class_corr 1 "S6" 2 "S5" 3 "S4" 4 "Not applicable"
la val class_corr class_corr
tab class_corr

//replacig the variable class_500 with the newly created variable class_corr
//but keep the original name class_500
drop class_500
rename class_corr class_500
order class_500, before(option_500)

	
